<%@page contentType="text/html" pageEncoding="UTF-8"%>
<%@ page language="java" import="java.sql.*, java.io.*, java.util.*, database.*" %>
<jsp:useBean id="con" class="database.DatabaseConnection"/>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
    <head>
        <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
        <title>Add Information</title>
        <style type="text/css">
            <!--
            body {
                background-image: url(../../image/3110_background/backcolor3.jpg);
            }
            .STYLE1 {
                color: #2a778b;
                font-size: 18px;
                font-weight: bold;
            }
            -->
        </style>
    </head>

    <body> 
        <table  width="635" height="138" align="center" border="0">
            <%
        con.createConnection();
        ResultSet rs = con.getCarBrandIcon();

        String brandName = null;
        String brandLogo = null;
        for (int i = 0; i < 3; i++) {
            %>
            <tr align="left" valign="top">
                <%
                for (int j = 0; j < 8; j++) {
                    if (rs.next()) {
                        brandName = rs.getString("Car_Brand_Name");
                        brandLogo = rs.getString("Car_Brand_Logo");
                %>
                <td width="75" height="55"><a href="add_info2.jsp?newsType=<%=brandName%>" target="mainFrame"><img src="./../../image/car_brand/<%=brandLogo%>" width="73" height="53" border="0"></a></td>
                <%
                    }
                }
                %>
            </tr>
            <%
        }
            %>
        </table>
    </body>
</html>
